CS5200 Fall 2020: Practicum 1

Conceptual Model: UML

View the conceptual model in Lucid Chart here:

https://app.lucidchart.com/invitations/accept/5602312e-dfc3-4423-975c-47190ce6022e

Logical Model: ERD

View the logical model in Lucid Chart here:

https://app.lucidchart.com/invitations/accept/7b497cbf-268d-4a03-b1a7-822b5a844fea

Schema

View the schema in Google Docs here:

https://docs.google.com/document/d/1o8pk51aed3BJSaBcwO2EMbT8I3ru_wpGTcTN4W-DbIM/edit?usp=sharing

Creating Database Tables

Should you wish to inspect the scripts that create the database and populate data, they can be found at:

https://github.com/eldss-classwork/databases-practicum1-scripts

The following images will show a progression from an empty database through table creation in MySQL Workbench.

The MySQL Workbench start screen.

The newly created, empty test database.

The test database after table creation.

Populating The Database

Queries